﻿CREATE TABLE [dbo].[GroupBranches] (
    [GroupBranchId]                     UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]                              NVARCHAR (50)    NOT NULL,
    [InsertDate]                        DATETIME         NULL,
    [UpdateDate]                        DATETIME         NULL,
    [Priority]                          INT              NOT NULL,
    [FrontEndLimitControl]              BIT              NOT NULL,
    [Debit]                             DECIMAL (18, 4)  NOT NULL,
    [Credit]                            DECIMAL (18, 4)  NOT NULL,
    [Balance]                           DECIMAL (18, 4)  NOT NULL,
    [DebitLimit]                        DECIMAL (18, 4)  NULL,
    [Email]                             NVARCHAR (200)   NULL,
    [LocalInputDirectory]               NVARCHAR (500)   NULL,
    [LocalOutputDirectory]              NVARCHAR (500)   NULL,
    [RemoteInputDirectory]              NVARCHAR (500)   NULL,
    [RemoteOutputDirectory]             NVARCHAR (500)   NULL,
    [LocalInputNotificationDirectory]   NVARCHAR (500)   NULL,
    [LocalOutputNotificationDirectory]  NVARCHAR (500)   NULL,
    [RemoteInputNotificationDirectory]  NVARCHAR (500)   NULL,
    [RemoteOutputNotificationDirectory] NVARCHAR (500)   NULL,
    [StartupDate]                       DATETIME         NULL,
    [CloseDownDate]                     DATETIME         NULL
);



